﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;

namespace PromotionApp.DAL
{
    public class LanguageDAL : BaseDAL
    {
        #region Private Variable

        private static LanguageDAL _LanguageDAL = null;

        #endregion

        #region Constructor

        private LanguageDAL() : base()
        {

        }

        #endregion

        #region Public Method

        public DataSet GetAllLanguage()
        {
            string strStoredProcedure = "LkLanguageSelectAll";
            List<SqlParameter> list = new List<SqlParameter>();
            DataSet ds = this._SQLHelper.GetDataSet(strStoredProcedure, list, CommandType.StoredProcedure);

            return ds;
        }

        public static LanguageDAL GetInstance()
        {
            if (_LanguageDAL == null)
                _LanguageDAL = new LanguageDAL();

            return _LanguageDAL;
        }

        #endregion
    }
}